<style type="text/css">
.div {
	width:1200px;
	height:auto;
	margin-top:25px;
	float:left;
	}
.trhead {
	background:#FF9900;
	}
</style>
<div class="box-search-data">
<table width="984" border="0" cellpadding="0" cellspacing="0">
<tr class="trhead">
	<td>No</td><td>Ticket Id</td><td>Reference ID</td><td>Vul Detail</td><td>Name</td><td>Open Datetime</td><td>Target Date</td><td>Close Date</td><td>Status</td><td>Level Of Impact</td><td>Prob Of Impact</td><td>Severity Level</td><td>Product</td>
</tr>
<?php
$no = 1;
/*foreach($show->result() as $show) {*/
$ql =mysql_query(" select a.*,b.product,c.name from(ticket a,product b,user c) where a.prod_id = b.prod_id and a.user_id = c.user_id  and product ='$prod_id' and severity_level ='$severity' and (ticket_id like('%$ticket_id %') ||  open_datetime like('%$date_time%') || title like('%$title%'))");
while($show = mysql_fetch_array($ql)) { 
?>


<tr>
	<td><?php echo $no++;?></td><td><a href="<?php echo site_url('search/search/search_alls/'.$show['ticket_id']);?>"><?php echo $show['ticket_id'];?></a></td><td><?php echo $show['reference_id'];?></td><td><?php echo $show['vul_detail'];?></td><td><?php echo $show['name'];?></td><td><?php echo $show['open_datetime'];?></td><td><?php echo $show['target_date'];?></td><td><?php echo $show['close_date'];?></td><td><?php echo $show['status'];?></td><td><?php echo $show['level_o_impact'];?></td><td><?php echo $show['prob_o_impact'];?></td><td><?php echo $show['severity_level'];?></td><td><?php echo $show['product'];?></td>
</tr>

<?php
	} 
?>
</table>
</div>